USE MattTest;

IF OBJECT_ID('MattTest.dbo.CSVSample') IS NOT NULL DROP TABLE MattTest.dbo.CSVSample;
GO

CREATE TABLE MattTest.dbo.CSVSample ( data NVARCHAR(max))
Go


BULK	INSERT MattTest.dbo.[CSVSample] 
	FROM '\\P1SSISV0001\import\Carrier\UPS\P00000376KE-20150314.csv'
	WITH (
			ROWTERMINATOR='0x0A',
			ERRORFILE = 'C:\BulkFileProblem.log'
		);
GO